<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="guc-cat-list">
  <title id="kh155019">Parameter Categories</title>
  <body>
    <p>Configuration parameters affect categories of server behaviors, such as resource consumption,
      query tuning, and authentication. The following topics describe Greenplum configuration
      parameter categories.</p>
    <ul id="ul_blz_1kk_wy">
      <li id="kh158485">
        <xref href="#topic12" type="topic" format="dita"/>
      </li>
      <li id="kh158498">
        <xref href="#topic15" type="topic" format="dita"/>
      </li>
      <li>
        <xref href="#topic57" type="topic" format="dita"/>
      </li>
      <li id="kh158520">
        <xref href="#topic21" type="topic" format="dita"/>
      </li>
      <li id="kh158533">
        <xref href="#topic29" type="topic" format="dita"/>
      </li>
      <li id="kh171207">
        <xref href="#topic33" type="topic" format="dita"/>
      </li>
      <li id="kh158545">
        <xref href="#topic37" type="topic" format="dita"/>
      </li>
      <li id="kh166320">
        <xref href="#topic38" type="topic" format="dita"/>
      </li>
      <li id="kh158554">
        <xref href="#topic39" type="topic" format="dita"/>
      </li>
      <li id="kh158572">
        <xref href="#topic43" type="topic" format="dita"/>
      </li>
      <li id="kh158581">
        <xref href="#topic44" type="topic" format="dita"/>
      </li>
      <li id="kh1585815">
        <xref href="#topic444" type="topic" format="dita"/>
      </li>
      <li id="kh158590">
        <xref href="#topic45" type="topic" format="dita"/>
      </li>
      <li>
        <xref href="#topic46" type="topic" format="dita"/>
      </li>
      <li id="kh158599">
        <xref href="#topic48" type="topic" format="dita"/>
      </li>
      <li id="kh158608">
        <xref href="#topic49" type="topic" format="dita"/>
      </li>
      <li id="kh184388">
        <xref href="#topic55" type="topic" format="dita"/>
      </li>
      <li>
        <xref href="#topic56" type="topic" format="dita"/>
      </li>
    </ul>
  </body>
  <topic id="topic12" xml:lang="en">
    <title id="kh155037">Connection and Authentication Parameters</title>
    <body>
      <p>These parameters control how clients connect and authenticate to Greenplum Database.</p>
    </body>
    <topic id="topic13" xml:lang="en">
      <title>Connection Parameters</title>
      <body>
        <simpletable id="kh159468" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#client_connection_check_interval" type="section"
                  >client_connection_check_interval</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_connection_send_timeout" type="section"
                  >gp_connection_send_timeout</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_dispatch_keepalives_count" type="section"
                  >gp_dispatch_keepalives_count</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_dispatch_keepalives_idle" type="section"
                  >gp_dispatch_keepalives_idle</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_dispatch_keepalives_interval" type="section"
                  >gp_dispatch_keepalives_interval</xref>
              </p>              
              <p>
                <xref href="guc-list.xml#gp_vmem_idle_resource_timeout" type="section"
                  >gp_vmem_idle_resource_timeout</xref>
              </p>
              <p>
                <xref href="guc-list.xml#listen_addresses" type="section">listen_addresses</xref>
              </p>
              <p>
                <xref href="guc-list.xml#max_connections" type="section">max_connections</xref>
              </p>
              <p>
                <xref href="guc-list.xml#max_prepared_transactions" type="section"
                  >max_prepared_transactions</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#superuser_reserved_connections" type="section"
                  >superuser_reserved_connections</xref>
              </p>
              <p>
                <xref href="guc-list.xml#tcp_keepalives_count" type="section"
                  >tcp_keepalives_count</xref>
              </p>
              <p>
                <xref href="guc-list.xml#tcp_keepalives_idle" type="section"
                  >tcp_keepalives_idle</xref>
              </p>
              <p>
                <xref href="guc-list.xml#tcp_keepalives_interval" type="section"
                  >tcp_keepalives_interval</xref>
              </p>
              <p>
                <xref href="guc-list.xml#unix_socket_directory" type="section"
                  >unix_socket_directories</xref>
              </p>
              <p>
                <xref href="guc-list.xml#unix_socket_group" type="section">unix_socket_group</xref>
              </p>
              <p>
                <xref href="guc-list.xml#unix_socket_permissions" type="section"
                  >unix_socket_permissions</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic14" xml:lang="en">
      <title>Security and Authentication Parameters</title>
      <body>
        <simpletable id="kh159695" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#authentication_timeout" type="section"
                  >authentication_timeout</xref>
              </p>
              <p>
                <xref href="guc-list.xml#db_user_namespace" type="section">db_user_namespace</xref>
              </p>
              <p>
                <xref href="guc-list.xml#krb_caseins_users" type="section">krb_caseins_users</xref>
              </p>
              <p>
                <xref href="guc-list.xml#krb_server_keyfile" type="section"
                  >krb_server_keyfile</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#password_encryption" type="section"
                  >password_encryption</xref>
              </p>
              <p>
                <xref href="guc-list.xml#password_hash_algorithm" type="section"
                  >password_hash_algorithm</xref>
              </p>
              <p>
                <xref href="guc-list.xml#ssl" type="section">ssl</xref>
              </p>
              <p>
                <xref href="guc-list.xml#ssl_ciphers" type="section">ssl_ciphers</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic15" xml:lang="en">
    <title id="kh155038">System Resource Consumption Parameters</title>
    <abstract>These parameters set the limits for system resources consumed by Greenplum
      Database.</abstract>
    <topic id="topic16" xml:lang="en">
      <title>Memory Consumption Parameters</title>
      <body>
        <p>These parameters control system memory usage.</p>
        <simpletable id="kh160388" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_vmem_idle_resource_timeout" type="section"
                  >gp_vmem_idle_resource_timeout</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_resource_group_memory_limit" type="section"
                  >gp_resource_group_memory_limit</xref> (resource group-based resource management) </p>
              <p>
                <xref href="guc-list.xml#gp_vmem_protect_limit" type="section"
                  >gp_vmem_protect_limit</xref> (resource queue-based resource management) </p>
              <p>
                <xref href="guc-list.xml#gp_vmem_protect_segworker_cache_limit" type="section"
                  >gp_vmem_protect_segworker_cache_limit</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_workfile_limit_files_per_query" type="section"
                  >gp_workfile_limit_files_per_query</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_workfile_limit_per_query" type="section"
                  >gp_workfile_limit_per_query</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_workfile_limit_per_segment" type="section"
                  >gp_workfile_limit_per_segment</xref>
              </p>
              <p><xref href="guc-list.xml#maintenance_work_mem" format="dita"/></p>
              <p>
                <xref href="guc-list.xml#max_stack_depth" type="section">max_stack_depth</xref>
              </p>
              <p>
                <xref href="guc-list.xml#shared_buffers" type="section">shared_buffers</xref>
              </p>
              <p>
                <xref href="guc-list.xml#temp_buffers" type="section">temp_buffers</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic18" xml:lang="en">
      <title>OS Resource Parameters</title>
      <body>
        <simpletable id="d1e422" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#max_files_per_process" type="section"
                  >max_files_per_process</xref>
              </p>
              <p>
                <xref href="guc-list.xml#shared_preload_libraries" type="section"
                  >shared_preload_libraries</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic19" xml:lang="en">
      <title>Cost-Based Vacuum Delay Parameters</title>
      <body>
        <note type="warning">Do not use cost-based vacuum delay because it runs asynchronously among
          the segment instances. The vacuum cost limit and delay is invoked at the segment level
          without taking into account the state of the entire Greenplum Database array</note>
        <p>You can configure the execution cost of <codeph>VACUUM</codeph> and
            <codeph>ANALYZE</codeph> commands to reduce the I/O impact on concurrent database
          activity. When the accumulated cost of I/O operations reaches the limit, the process
          performing the operation sleeps for a while, Then resets the counter and continues
          execution</p>
        <simpletable id="kh161372" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#vacuum_cost_delay" type="section">vacuum_cost_delay</xref>
              </p>
              <p>
                <xref href="guc-list.xml#vacuum_cost_limit" type="section">vacuum_cost_limit</xref>
              </p>
              <p>
                <xref href="guc-list.xml#vacuum_cost_page_dirty" type="section"
                  >vacuum_cost_page_dirty</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#vacuum_cost_page_hit" type="section"
                  >vacuum_cost_page_hit</xref>
              </p>
              <p>
                <xref href="guc-list.xml#vacuum_cost_page_miss" type="section"
                  >vacuum_cost_page_miss</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic20" xml:lang="en">
      <title>Transaction ID Management Parameters</title>
      <body>
        <simpletable id="d1e474" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#xid_stop_limit" type="section">xid_stop_limit</xref>
              </p>
              <p>
                <xref href="guc-list.xml#xid_warn_limit" type="section">xid_warn_limit</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic57">
    <title>GPORCA Parameters</title>
    <body>
      <p>These parameters control the usage of GPORCA by Greenplum Database. For information about
        GPORCA, see <xref href="../../admin_guide/query/topics/query-piv-optimizer.html" format="html" scope="external">About GPORCA</xref> <ph otherprops="op-print"> in the <cite>Greenplum Database Administrator
            Guide</cite></ph>. </p>
      <simpletable frame="none" id="simpletable_nq5_z2c_kr">
        <strow>
          <stentry>
            <p><xref href="guc-list.xml#gp_enable_relsize_collection" format="dita"
                >gp_enable_relsize_collection</xref></p>
            <p><xref href="guc-list.xml#optimizer" type="section">optimizer</xref>
            </p>
            <p>
              <xref href="guc-list.xml#optimizer_analyze_root_partition" type="section"
                >optimizer_analyze_root_partition</xref>
            </p>
            <p>
              <xref href="guc-list.xml#optimizer_array_expansion_threshold" type="section"
                >optimizer_array_expansion_threshold</xref></p>
            <p><xref href="guc-list.xml#optimizer_control" type="section">optimizer_control</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_cost_model" type="section"
                >optimizer_cost_model</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_cte_inlining_bound" type="section"
                >optimizer_cte_inlining_bound</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_dpe_stats" type="section"
                >optimizer_dpe_stats</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_enable_associativity" type="section"
                >optimizer_enable_associativity</xref></p>
            <p><xref href="guc-list.xml#optimizer_enable_dml" type="section"
                >optimizer_enable_dml</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_enable_indexonlyscan" type="section"
                >optimizer_enable_indexonlyscan</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_enable_master_only_queries" type="section"
                >optimizer_enable_master_only_queries</xref></p>
            <p><xref href="guc-list.xml#optimizer_enable_multiple_distinct_aggs" type="section"
              >optimizer_enable_multiple_distinct_aggs</xref></p>
            <p><xref href="guc-list.xml#optimizer_enable_orderedagg" type="section"
                >optimizer_enable_orderedagg</xref></p>
            <p><xref href="guc-list.xml#optimizer_force_agg_skew_avoidance" type="section"
                >optimizer_force_agg_skew_avoidance</xref></p>
            <p><xref href="guc-list.xml#optimizer_force_comprehensive_join_implementation" type="section"
                >optimizer_force_comprehensive_join_implementation</xref>
            </p>
          </stentry>
          <stentry>
            <p><xref href="guc-list.xml#optimizer_force_multistage_agg" type="section"
                >optimizer_force_multistage_agg</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_force_three_stage_scalar_dqa" type="section"
                >optimizer_force_three_stage_scalar_dqa</xref></p>
            <p><xref href="guc-list.xml#optimizer_join_arity_for_associativity_commutativity"
                type="section">optimizer_join_arity_for_associativity_commutativity</xref></p>
            <p><xref href="guc-list.xml#optimizer_join_order" format="dita" type="section"
                >optimizer_join_order</xref></p>
            <p><xref href="guc-list.xml#optimizer_join_order_threshold" format="dita"
                >optimizer_join_order_threshold</xref></p>
            <p><xref href="guc-list.xml#optimizer_mdcache_size" type="section"
                >optimizer_mdcache_size</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_metadata_caching" type="section"
                >optimizer_metadata_caching</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_parallel_union" type="section"
                >optimizer_parallel_union</xref></p>
            <p><xref href="guc-list.xml#optimizer_penalize_skew" type="section"
                >optimizer_penalize_skew</xref></p>
            <p><xref href="guc-list.xml#optimizer_print_missing_stats" type="section"
                >optimizer_print_missing_stats</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_print_optimization_stats" type="section"
                >optimizer_print_optimization_stats</xref>
            </p>
            <p><xref href="guc-list.xml#optimizer_sort_factor" format="dita"
                >optimizer_sort_factor</xref></p>
            <p><xref href="guc-list.xml#optimizer_use_gpdb_allocators" format="dita"
                >optimizer_use_gpdb_allocators</xref></p>
            <p><xref href="guc-list.xml#optimizer_xform_bind_threshold" format="dita"
                >optimizer_xform_bind_threshold</xref></p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic21" xml:lang="en">
    <title id="kh183779">Query Tuning Parameters</title>
    <abstract>These parameters control aspects of SQL query processing such as query operators and
      operator settings and statistics sampling.</abstract>
    <topic id="topic22" xml:lang="en">
      <title>Postgres Planner Control Parameters</title>
      <body>
        <p>The following parameters control the types of plan operations the Postgres Planner can
          use. Enable or disable plan operations to force the Postgres Planner to choose a different
          plan. This is useful for testing and comparing query performance using different plan
          types.</p>
        <simpletable id="kh158625" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#enable_bitmapscan" type="section">enable_bitmapscan</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_groupagg" type="section">enable_groupagg</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_hashagg" type="section">enable_hashagg</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_hashjoin" type="section">enable_hashjoin</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_indexscan" type="section">enable_indexscan</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_mergejoin" type="section">enable_mergejoin</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_nestloop" type="section">enable_nestloop</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_seqscan" type="section">enable_seqscan</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_sort" type="section">enable_sort</xref>
              </p>
              <p>
                <xref href="guc-list.xml#enable_tidscan" type="section">enable_tidscan</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_agg_distinct" type="section"
                  >gp_enable_agg_distinct</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_enable_agg_distinct_pruning" type="section"
                  >gp_enable_agg_distinct_pruning</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_direct_dispatch" type="section"
                  >gp_enable_direct_dispatch</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_fast_sri" type="section"
                  >gp_enable_fast_sri</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_groupext_distinct_gather" type="section"
                  >gp_enable_groupext_distinct_gather</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_groupext_distinct_pruning" type="section"
                  >gp_enable_groupext_distinct_pruning</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_multiphase_agg" type="section"
                  >gp_enable_multiphase_agg</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_predicate_propagation" type="section"
                  >gp_enable_predicate_propagation</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_preunique" type="section"
                  >gp_enable_preunique</xref></p>
              <p>
                <xref href="guc-list.xml#gp_enable_relsize_collection" format="dita"
                  >gp_enable_relsize_collection</xref></p>
              <p>
                <xref href="guc-list.xml#gp_enable_sort_distinct" type="section"
                  >gp_enable_sort_distinct</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_sort_limit" type="section"
                  >gp_enable_sort_limit</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic23" xml:lang="en">
      <title>Postgres Planner Costing Parameters</title>
      <body>
        <note type="warning">Do not adjust these query costing parameters. They are tuned to reflect
          Greenplum Database hardware configurations and typical workloads. All of these parameters
          are related. Changing one without changing the others can have adverse affects on
          performance.</note>
        <simpletable id="kh181234" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#cpu_index_tuple_cost" type="section"
                  >cpu_index_tuple_cost</xref>
              </p>
              <p>
                <xref href="guc-list.xml#cpu_operator_cost" type="section">cpu_operator_cost</xref>
              </p>
              <p>
                <xref href="guc-list.xml#cpu_tuple_cost" type="section">cpu_tuple_cost</xref>
              </p>
              <p>
                <xref href="guc-list.xml#cursor_tuple_fraction" type="section"
                  >cursor_tuple_fraction</xref>
              </p>
              <p>
                <xref href="guc-list.xml#effective_cache_size" type="section"
                  >effective_cache_size</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_motion_cost_per_row" type="section"
                  >gp_motion_cost_per_row</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_segments_for_planner" type="section"
                  >gp_segments_for_planner</xref>
              </p>
              <p>
                <xref href="guc-list.xml#random_page_cost" type="section">random_page_cost</xref>
              </p>
              <p>
                <xref href="guc-list.xml#seq_page_cost" type="section">seq_page_cost</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic24" xml:lang="en">
      <title>Database Statistics Sampling Parameters</title>
      <body>
        <p>These parameters adjust the amount of data sampled by an <codeph>ANALYZE</codeph>
          operation. Adjusting these parameters affects statistics collection system-wide. You can
          configure statistics collection on particular tables and columns by using the
            <codeph>ALTER TABLE</codeph><codeph>SET STATISTICS</codeph> clause.</p>
        <simpletable id="d1e655" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#default_statistics_target" type="section"
                  >default_statistics_target </xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic25" xml:lang="en">
      <title>Sort Operator Configuration Parameters</title>
      <body>
        <simpletable id="d1e668" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_enable_sort_distinct" type="section"
                  >gp_enable_sort_distinct</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_sort_limit" type="section"
                  >gp_enable_sort_limit</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic26" xml:lang="en">
      <title>Aggregate Operator Configuration Parameters</title>
      <body>
        <simpletable id="kh162730" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_enable_agg_distinct" type="section"
                  >gp_enable_agg_distinct</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_agg_distinct_pruning" type="section"
                  >gp_enable_agg_distinct_pruning</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_multiphase_agg" type="section"
                  >gp_enable_multiphase_agg</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_preunique" type="section"
                  >gp_enable_preunique</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_enable_groupext_distinct_gather" type="section"
                  >gp_enable_groupext_distinct_gather</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_groupext_distinct_pruning" type="section"
                  >gp_enable_groupext_distinct_pruning</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_workfile_compression" type="section"
                  >gp_workfile_compression</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic27" xml:lang="en">
      <title>Join Operator Configuration Parameters</title>
      <body>
        <simpletable id="kh162782" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#join_collapse_limit" type="section"
                  >join_collapse_limit</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_adjust_selectivity_for_outerjoins" type="section"
                  >gp_adjust_selectivity_for_outerjoins</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_hashjoin_tuples_per_bucket" type="section"
                  >gp_hashjoin_tuples_per_bucket</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_statistics_use_fkeys" type="section"
                  >gp_statistics_use_fkeys</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_workfile_compression" type="section"
                  >gp_workfile_compression</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic28" xml:lang="en">
      <title>Other Postgres Planner Configuration Parameters</title>
      <body>
        <simpletable id="d1e746" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#from_collapse_limit" type="section"
                  >from_collapse_limit</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_predicate_propagation" type="section"
                  >gp_enable_predicate_propagation</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_max_plan_size" type="section">gp_max_plan_size</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_statistics_pullup_from_child_partition" type="section"
                  >gp_statistics_pullup_from_child_partition</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic_zd5_p32_mdb">
      <title>Query Plan Execution</title>
      <body>
        <p>Control the query plan execution.</p>
        <simpletable frame="none" id="simpletable_kbx_t32_mdb">
          <strow>
            <stentry>
              <p><xref href="guc-list.xml#gp_max_slices">gp_max_slices</xref></p>
              <p><xref href="guc-list.xml#plan_cache_mode">plan_cache_mode</xref></p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic29" xml:lang="en">
    <title id="kh155046">Error Reporting and Logging Parameters</title>
    <abstract>These configuration parameters control Greenplum Database logging. </abstract>
    <topic id="topic30" xml:lang="en">
      <title>Log Rotation</title>
      <body>
        <simpletable id="kh163344" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#log_rotation_age" type="section">log_rotation_age</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_rotation_size" type="section">log_rotation_size</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#log_truncate_on_rotation" type="section"
                  >log_truncate_on_rotation</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic31" xml:lang="en">
      <title>When to Log</title>
      <body>
        <simpletable id="kh163424" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#client_min_messages" type="section"
                  >client_min_messages</xref>
              </p>
              <p><xref href="guc-list.xml#gp_interconnect_debug_retry_interval"
                  >gp_interconnect_debug_retry_interval</xref></p>
              <p>
                <xref href="guc-list.xml#log_error_verbosity" type="section"
                  >log_error_verbosity</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_file_mode" type="section"
                  >log_file_mode</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_min_duration_statement" type="section"
                  >log_min_duration_statement</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#log_min_error_statement" type="section"
                  >log_min_error_statement</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_min_messages" type="section">log_min_messages</xref>
              </p>
              <p>
                <xref href="guc-list.xml#optimizer_minidump" type="section"
                  >optimizer_minidump</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic32" xml:lang="en">
      <title>What to Log</title>
      <body>
        <simpletable id="kh171216" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#debug_pretty_print" type="section"
                  >debug_pretty_print</xref>
              </p>
              <p>
                <xref href="guc-list.xml#debug_print_parse" type="section">debug_print_parse</xref>
              </p>
              <p>
                <xref href="guc-list.xml#debug_print_plan" type="section">debug_print_plan</xref>
              </p>
              <p>
                <xref href="guc-list.xml#debug_print_prelim_plan" type="section"
                  >debug_print_prelim_plan</xref>
              </p>
              <p>
                <xref href="guc-list.xml#debug_print_rewritten" type="section"
                  >debug_print_rewritten</xref>
              </p>
              <p>
                <xref href="guc-list.xml#debug_print_slice_table" type="section"
                  >debug_print_slice_table</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_log_format" type="section">gp_log_format</xref>
              </p>
              <p><xref href="guc-list.xml#gp_log_interconnect">gp_log_interconnect</xref>
              </p>
              <p><xref href="guc-list.xml#gp_log_resqueue_priority_sleep_time">gp_log_resqueue_priority_sleep_time</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_autostats" type="section">log_autostats</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_connections" type="section">log_connections</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_disconnections" type="section"
                  >log_disconnections</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#log_dispatch_stats" type="section"
                  >log_dispatch_stats</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_duration" type="section">log_duration</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_executor_stats" type="section"
                  >log_executor_stats</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_hostname" type="section">log_hostname</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_parser_stats" type="section">log_parser_stats</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_planner_stats" type="section">log_planner_stats</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_statement" type="section">log_statement</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_statement_stats" type="section"
                  >log_statement_stats</xref>
              </p>
              <p>
                <xref href="guc-list.xml#log_timezone" type="section">log_timezone</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_debug_linger" type="section">gp_debug_linger</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_reraise_signal" type="section">gp_reraise_signal</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic33" xml:lang="en">
    <title id="kh171299">System Monitoring Parameters</title>
    <abstract>These configuration parameters control Greenplum Database data collection and
      notifications related to database monitoring.</abstract>
    <topic id="topic36" xml:lang="en">
      <title>Greenplum Performance Database</title>
      <body>
        <p>The following parameters configure the data collection agents that populate the
            <codeph>gpperfmon</codeph> database.</p>
        <simpletable id="kh171891" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_enable_gpperfmon" type="section"
                  >gp_enable_gpperfmon</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_gpperfmon_send_interval" type="section"
                  >gp_gpperfmon_send_interval</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gpperfmon_log_alert_level" type="section"
                  >gpperfmon_log_alert_level</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gpperfmon_port" type="section">gpperfmon_port</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="query-metrics">
      <title>Query Metrics Collection Parameters</title>
      <body>
        <p>These parameters enable and configure query metrics collection. When enabled, Greenplum
          Database saves metrics to shared memory during query execution. These metrics are used by
          Tanzu Greenplum Command Center, which is included with VMware's commercial version of
          Greenplum Database.</p>
        <simpletable id="query-metrics" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_enable_query_metrics" type="section"
                  >gp_enable_query_metrics</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_instrument_shmem_size" type="section"
                  >gp_instrument_shmem_size</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic37" xml:lang="en">
    <title id="kh171364">Runtime Statistics Collection Parameters</title>
    <body>
      <p>These parameters control the server statistics collection feature. When statistics
        collection is enabled, you can access the statistics data using the <i>pg_stat</i> family of
        system catalog views.</p>
      <simpletable id="kh171301" frame="none">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#stats_queue_level" type="section">stats_queue_level</xref>
            </p>
            <p>
              <xref href="guc-list.xml#track_activities" type="section"/>
            </p>
          </stentry>
          <stentry>
            <p>
              <xref href="guc-list.xml#track_counts" type="section">track_counts</xref>
            </p>
            <p>
              <xref href="guc-list.xml#update_process_title" type="section"
                >update_process_title</xref>
            </p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic38" xml:lang="en">
    <title id="kh155054">Automatic Statistics Collection Parameters</title>
    <body>
      <p>When automatic statistics collection is enabled, you can run <codeph>ANALYZE</codeph>
        automatically in the same transaction as an <codeph>INSERT</codeph>,
        <codeph>UPDATE</codeph>, <codeph>DELETE</codeph>, <codeph>COPY</codeph> or <codeph>CREATE
          TABLE...AS SELECT</codeph> statement when a certain threshold of rows is affected
          (<codeph>on_change</codeph>), or when a newly generated table has no statistics
          (<codeph>on_no_stats</codeph>). To enable this feature, set the following server
        configuration parameters in your Greenplum Database master <codeph>postgresql.conf</codeph>
        file and restart Greenplum Database: </p>
      <simpletable id="d1e1057" frame="none">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#gp_autostats_allow_nonowner" type="section">gp_autostats_allow_nonowner</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_autostats_mode" type="section">gp_autostats_mode</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_autostats_mode_in_functions" type="section"
                >gp_autostats_mode_in_functions</xref>
            </p>
          </stentry>
          <stentry>
            <p>
              <xref href="guc-list.xml#gp_autostats_on_change_threshold" type="section"
                >gp_autostats_on_change_threshold</xref>
            </p>
            <p>
              <xref href="guc-list.xml#log_autostats" type="section">log_autostats</xref>
            </p>
          </stentry>
        </strow>
      </simpletable>
      <note type="warning">Depending on the specific nature of your database operations, automatic
        statistics collection can have a negative performance impact. Carefully evaluate whether the
        default setting of <codeph>on_no_stats</codeph> is appropriate for your system.</note>
    </body>
  </topic>
  <topic id="topic39" xml:lang="en">
    <title id="kh181507">Client Connection Default Parameters</title>
    <abstract>These configuration parameters set defaults that are used for client
      connections.</abstract>
    <topic id="topic40" xml:lang="en">
      <title>Statement Behavior Parameters</title>
      <body>
        <simpletable id="kh163609" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#check_function_bodies" type="section"
                  >check_function_bodies</xref>
              </p>
              <p>
                <xref href="guc-list.xml#default_tablespace" type="section"
                  >default_tablespace</xref>
              </p>
              <p>
                <xref href="guc-list.xml#default_transaction_deferrable"/>
              </p>
              <p>
                <xref href="guc-list.xml#default_transaction_isolation" type="section"
                  >default_transaction_isolation</xref>
              </p>
            </stentry>
            <stentry><xref href="guc-list.xml#default_transaction_read_only" type="section"
                >default_transaction_read_only</xref><p>
                <xref href="guc-list.xml#search_path" type="section">search_path</xref>
              </p><p>
                <xref href="guc-list.xml#statement_timeout" type="section">statement_timeout</xref>
              </p><p><xref href="guc-list.xml#topic_k52_fqm_f3b"/></p><p>
                <xref href="guc-list.xml#vacuum_freeze_min_age" type="section"
                  >vacuum_freeze_min_age</xref>
              </p></stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic41" xml:lang="en">
      <title>Locale and Formatting Parameters</title>
      <body>
        <simpletable id="kh163748" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#client_encoding" type="section">client_encoding</xref>
              </p>
              <p>
                <xref href="guc-list.xml#DateStyle" type="section">DateStyle</xref>
              </p>
              <p>
                <xref href="guc-list.xml#extra_float_digits" type="section"
                  >extra_float_digits</xref>
              </p>
              <p>
                <xref href="guc-list.xml#IntervalStyle" type="section">IntervalStyle</xref>
              </p>
              <p>
                <xref href="guc-list.xml#lc_collate" type="section">lc_collate</xref>
              </p>
              <p>
                <xref href="guc-list.xml#lc_ctype" type="section">lc_ctype</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#lc_messages" type="section">lc_messages</xref>
              </p>
              <p>
                <xref href="guc-list.xml#lc_monetary" type="section">lc_monetary</xref>
              </p>
              <p>
                <xref href="guc-list.xml#lc_numeric" type="section">lc_numeric</xref>
              </p>
              <p>
                <xref href="guc-list.xml#lc_time" type="section">lc_time</xref>
              </p>
              <p>
                <xref href="guc-list.xml#TimeZone" type="section">TimeZone</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic42" xml:lang="en">
      <title>Other Client Default Parameters</title>
      <body>
        <simpletable id="kh164407" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#dynamic_library_path" type="section"
                  >dynamic_library_path</xref>
              </p>
              <p>
                <xref href="guc-list.xml#explain_pretty_print" type="section"
                  >explain_pretty_print</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#local_preload_libraries" type="section"
                  >local_preload_libraries</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic43" xml:lang="en">
    <title id="kh163788">Lock Management Parameters</title>
    <abstract>These configuration parameters set limits for locks and deadlocks.</abstract>
    <body>
      <simpletable id="d1e1187" frame="none">
        <strow>
          <stentry><p>
              <xref href="guc-list.xml#deadlock_timeout" type="section">deadlock_timeout</xref>
            </p><xref href="guc-list.xml#gp_enable_global_deadlock_detector" type="section"
              >gp_enable global_deadlock_detector</xref><p>
              <xref href="guc-list.xml#gp_global_deadlock_detector_period" type="section"
                >gp_global_deadlock_detector_period</xref>
            </p></stentry>
          <stentry>
            <p>
              <xref href="guc-list.xml#lock_timeout" type="section">lock_timeout</xref>
            </p>
            <p>
              <xref href="guc-list.xml#max_locks_per_transaction" type="section"
                >max_locks_per_transaction</xref>
            </p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic44" xml:lang="en">
    <title id="kh155069">Resource Management Parameters (Resource Queues)</title>
    <body>
      <p>The following configuration parameters configure the Greenplum Database resource management
        feature (resource queues), query prioritization, memory utilization and concurrency control. </p>
      <simpletable id="kh157161" frame="none">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#gp_log_resqueue_priority_sleep_time" type="section"
                >gp_log_resqueue_priority_sleep_time</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_resqueue_memory_policy" type="section"
                >gp_resqueue_memory_policy</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_resqueue_priority" type="section"
                >gp_resqueue_priority</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_resqueue_priority_cpucores_per_segment" type="section"
                >gp_resqueue_priority_cpucores_per_segment</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_resqueue_priority_sweeper_interval" type="section"
                >gp_resqueue_priority_sweeper_interval</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_vmem_idle_resource_timeout" type="section"
                >gp_vmem_idle_resource_timeout</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_vmem_protect_limit" type="section"
                >gp_vmem_protect_limit</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_vmem_protect_segworker_cache_limit" type="section"
                >gp_vmem_protect_segworker_cache_limit</xref>
            </p>
            <p>
              <xref href="guc-list.xml#max_resource_queues" type="section"
                >max_resource_queues</xref>
            </p>
          </stentry>
          <stentry>
            <p>
              <xref href="guc-list.xml#max_resource_portals_per_transaction" type="section"
                >max_resource_portals_per_transaction</xref>
            </p>
            <p>
              <xref href="guc-list.xml#max_statement_mem" type="section">max_statement_mem</xref>
            </p>
            <p>
              <xref href="guc-list.xml#resource_cleanup_gangs_on_wait" type="section"
                >resource_cleanup_gangs_on_wait</xref>
            </p>
            <p>
              <xref href="guc-list.xml#resource_select_only" type="section"
                >resource_select_only</xref>
            </p>
            <p>
              <xref href="guc-list.xml#runaway_detector_activation_percent" type="section"
                >runaway_detector_activation_percent</xref>
            </p>
            <p>
              <xref href="guc-list.xml#statement_mem" type="section">statement_mem</xref>
            </p>
            <p>
              <xref href="guc-list.xml#stats_queue_level" type="section">stats_queue_level</xref>
            </p>
            <p><xref href="guc-list.xml#vmem_process_interrupt" type="section"
                >vmem_process_interrupt</xref></p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic444" xml:lang="en">
    <title id="kh1550694">Resource Management Parameters (Resource Groups)</title>
    <body>
      <p>The following parameters configure the Greenplum Database resource group workload
        management feature. </p>
      <simpletable id="kh1571613" frame="none">
        <strow>
          <stentry><p>
              <xref href="guc-list.xml#gp_resgroup_memory_policy" type="section"
                >gp_resgroup_memory_policy</xref>
            </p>
            <xref href="guc-list.xml#gp_resource_group_bypass" type="section"
              >gp_resource_group_bypass</xref>
            <p>
              <xref href="guc-list.xml#gp_resource_group_cpu_ceiling_enforcement" type="section"
                >gp_resource_group_cpu_ceiling_enforcement</xref>
            </p><p>
              <xref href="guc-list.xml#gp_resource_group_cpu_limit" type="section"
                >gp_resource_group_cpu_limit</xref>
            </p><p>
              <xref href="guc-list.xml#gp_resource_group_memory_limit" type="section"
                >gp_resource_group_memory_limit</xref>
            </p><p>
              <xref href="guc-list.xml#gp_resource_group_queuing_timeout" type="section"
                >gp_resource_group_queuing_timeout</xref>
            </p><p>
              <xref href="guc-list.xml#gp_resource_group_move_timeout" type="section"
                >gp_resource_group_move_timeout</xref>
            </p><p>
              <xref href="guc-list.xml#gp_resource_manager" type="section"
                >gp_resource_manager</xref>
            </p></stentry>
          <stentry>
            <p>
              <xref href="guc-list.xml#gp_vmem_idle_resource_timeout" type="section"
                >gp_vmem_idle_resource_timeout</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_vmem_protect_segworker_cache_limit" type="section"
                >gp_vmem_protect_segworker_cache_limit</xref>
            </p>
            <p>
              <xref href="guc-list.xml#max_statement_mem" type="section">max_statement_mem</xref>
            </p>
            <p>
              <xref href="guc-list.xml#memory_spill_ratio" type="section">memory_spill_ratio</xref>
            </p>
            <p>
              <xref href="guc-list.xml#runaway_detector_activation_percent" type="section"
                >runaway_detector_activation_percent</xref>
            </p>
            <p>
              <xref href="guc-list.xml#statement_mem" type="section">statement_mem</xref>
            </p>
            <p><xref href="guc-list.xml#vmem_process_interrupt" type="section"
                >vmem_process_interrupt</xref></p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic45" xml:lang="en">
    <title id="kh155070">External Table Parameters</title>
    <body>
      <p>The following parameters configure the external tables feature of Greenplum Database.</p>
      <simpletable id="kh164454" frame="none">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#gp_external_enable_exec" type="section"
                >gp_external_enable_exec</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_external_enable_filter_pushdown" type="section"
                >gp_external_enable_filter_pushdown</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_external_max_segs" type="section"
                >gp_external_max_segs</xref>
            </p>
            <p>
              <xref href="guc-list.xml#topic_lvm_ttc_3p" type="section"
                >gp_initial_bad_row_limit</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_reject_percent_threshold" type="section"
                >gp_reject_percent_threshold</xref>
            </p>
          </stentry>
          <stentry>
            <p><xref href="guc-list.xml#gpfdist_retry_timeout" type="section"
                >gpfdist_retry_timeout</xref></p>
            <p>
              <xref href="guc-list.xml#readable_external_table_timeout" type="section"
                >readable_external_table_timeout</xref>
            </p>
            <p>
              <xref href="guc-list.xml#writable_external_table_bufsize" type="section"
                >writable_external_table_bufsize</xref></p>
            <p><xref href="guc-list.xml#verify_gpfdists_cert">verify_gpfdists_cert</xref></p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic46" xml:lang="en">
    <title id="kh155071">Database Table Parameters</title>
    <body>
      <p>The following parameter configures default option settings for Greenplum Database
        tables.</p>
      <simpletable id="d1e1287" frame="none">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#gp_create_table_random_default_distribution"
                >gp_create_table_random_default_distribution</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_default_storage_options">gp_default_storage_options</xref>
            </p>
            <p>
              <xref href="guc-list.xml#gp_enable_exchange_default_partition"
                >gp_enable_exchange_default_partition</xref>
            </p>
            <p><xref href="guc-list.xml#gp_enable_segment_copy_checking"
                >gp_enable_segment_copy_checking</xref></p>
            <p>
              <xref href="guc-list.xml#gp_use_legacy_hashops" type="section"
                >gp_use_legacy_hashops</xref></p>
          </stentry>
        </strow>
      </simpletable>
    </body>
    <topic id="topic_hfd_1tl_zp">
      <title>Append-Optimized Table Parameters</title>
      <body>
        <p>The following parameters configure the <ph>append-optimized</ph> tables feature of
          Greenplum Database.</p>
        <simpletable frame="none" id="simpletable_awg_1tl_zp">
          <strow>
            <stentry><p>
                <xref href="guc-list.xml#max_appendonly_tables" type="section"
                  >max_appendonly_tables</xref>
              </p><xref href="guc-list.xml#gp_add_column_inherits_table_setting"
                >gp_add_column_inherits_table_setting</xref>
              <p>
                <xref href="guc-list.xml#gp_appendonly_compaction" type="section"
                  >gp_appendonly_compaction</xref>
              </p><p>
                <xref href="guc-list.xml#gp_appendonly_compaction_threshold"/></p><p><xref
                  href="guc-list.xml#validate_previous_free_tid"/>
              </p></stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic48" xml:lang="en">
    <title id="kh178569">Past Version Compatibility Parameters</title>
    <body>
      <p>The following parameters provide compatibility with older PostgreSQL and Greenplum Database
        versions. You do not need to change these parameters in Greenplum Database.</p>
    </body>
    <topic id="topic_ax3_r1v_bdb">
      <title>PostgreSQL</title>
      <body>
        <simpletable frame="none" id="simpletable_bx3_r1v_bdb">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#array_nulls" type="section">array_nulls</xref>
              </p>
              <p>
                <xref href="guc-list.xml#backslash_quote" type="section">backslash_quote</xref>
              </p>
              <p>
                <xref href="guc-list.xml#escape_string_warning" type="section"
                  >escape_string_warning</xref>
              </p>
              <p>
                <xref href="guc-list.xml#quote_all_identifiers" type="section"
                  >quote_all_identifiers</xref>
              </p>
            </stentry>
            <stentry>
              <p><xref href="guc-list.xml#regex_flavor" type="section">regex_flavor</xref>
              </p>
              <p>
                <xref href="guc-list.xml#standard_conforming_strings" type="section"
                  >standard_conforming_strings</xref>
              </p>
              <p>
                <xref href="guc-list.xml#transform_null_equals" type="section"
                  >transform_null_equals</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic_jq1_n1v_bdb">
      <title>Greenplum Database</title>
      <body>
        <simpletable frame="none" id="simpletable_uy5_1bv_bdb">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#enable_implicit_timeformat_YYYYMMDDHH24MISS" type="section">enable_implicit_timeformat_YYYYMMDDHH24MISS</xref>
              </p>
              <p><xref href="guc-list.xml#gp_ignore_error_table">gp_ignore_error_table</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic49" xml:lang="en">
    <title id="kh182770">Greenplum Database Array Configuration Parameters</title>
    <body>
      <p>The parameters in this topic control the configuration of the Greenplum Database array and
        its components: segments, master, distributed transaction manager, master mirror, and
        interconnect.</p>
    </body>
    <topic id="topic50" xml:lang="en">
      <title>Interconnect Configuration Parameters</title>
      <body>
        <simpletable frame="none" id="simpletable_uxc_w3s_wv">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_interconnect_fc_method" type="section"
                  >gp_interconnect_fc_method</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_interconnect_proxy_addresses" type="section"
                  >gp_interconnect_proxy_addresses</xref></p>
              <p>
                <xref href="guc-list.xml#gp_interconnect_queue_depth" type="section"
                  >gp_interconnect_queue_depth</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_interconnect_setup_timeout" type="section"
                  >gp_interconnect_setup_timeout</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_interconnect_snd_queue_depth" type="section"
                  >gp_interconnect_snd_queue_depth</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_interconnect_transmit_timeout" type="section"
                  >gp_interconnect_transmit_timeout</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_interconnect_type" type="section"
                  >gp_interconnect_type</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_max_packet_size" type="section"
                  >gp_max_packet_size</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
        <note>Greenplum Database supports only the UDPIFC (default) and TCP interconnect
          types.</note>
      </body>
    </topic>
    <topic id="topic51" xml:lang="en">
      <title>Dispatch Configuration Parameters</title>
      <body>
        <simpletable id="kh162158" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_cached_segworkers_threshold" type="section"
                  >gp_cached_segworkers_threshold</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_enable_direct_dispatch" type="section"
                  >gp_enable_direct_dispatch</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_segment_connect_timeout" type="section"
                  >gp_segment_connect_timeout</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_set_proc_affinity" type="section"
                  >gp_set_proc_affinity</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic52" xml:lang="en">
      <title>Fault Operation Parameters</title>
      <body>
        <simpletable id="kh165991" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_set_read_only" type="section">gp_set_read_only</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_fts_probe_interval" type="section"
                  >gp_fts_probe_interval</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_fts_probe_retries" type="section"
                  >gp_fts_probe_retries</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_fts_probe_timeout" format="dita"/>
              </p>
              <p>
                <xref href="guc-list.xml#gp_fts_replication_attempt_count" type="section"
                  >gp_fts_replication_attempt_count</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_log_fts" format="dita"/>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic53" xml:lang="en">
      <title>Distributed Transaction Management Parameters</title>
      <body>
        <simpletable id="d1e1450" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_max_local_distributed_cache" type="section"
                  >gp_max_local_distributed_cache</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#dtx_phase2_retry_count" type="section"
                  >dtx_phase2_retry_count</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
    <topic id="topic54" xml:lang="en">
      <title>Read-Only Parameters</title>
      <body>
        <simpletable id="d1e1459" frame="none">
          <strow>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_command_count" type="section">gp_command_count</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_content" type="section">gp_content</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_dbid" type="section">gp_dbid</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_retrieve_conn" type="section">gp_retrieve_conn</xref>
              </p>
            </stentry>
            <stentry>
              <p>
                <xref href="guc-list.xml#gp_role" type="section">gp_role</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_session_id" type="section">gp_session_id</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_server_version" type="section">gp_server_version</xref>
              </p>
              <p>
                <xref href="guc-list.xml#gp_server_version_num" type="section"
                  >gp_server_version_num</xref>
              </p>
            </stentry>
          </strow>
        </simpletable>
      </body>
    </topic>
  </topic>
  <topic id="topic55" xml:lang="en">
    <title id="kh184289">Greenplum Mirroring Parameters for Master and Segments</title>
    <body>
      <p>These parameters control the configuration of the replication between Greenplum Database
        primary master and standby master.</p>
      <simpletable id="d1e1490" frame="none">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#max_slot_wal_keep_size" type="section"
                >max_slot_wal_keep_size</xref>
            </p>
            <p><xref href="guc-list.xml#repl_catchup_within_range" type="section"
                >repl_catchup_within_range</xref>
            </p>
            <p>
              <xref href="guc-list.xml#replication_timeout" type="section"
                >replication_timeout</xref>
            </p>
            <p><xref href="guc-list.xml#wait_for_replication_threshold" type="section"
                >wait_for_replication_threshold</xref>
            </p>
            <p><xref href="guc-list.xml#wal_keep_segments" type="section">wal_keep_segments</xref>
            </p>
            <p>
              <xref href="guc-list.xml#wal_receiver_status_interval" type="section"
                >wal_receiver_status_interval</xref>
            </p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic56">
    <title>Greenplum PL/Java Parameters</title>
    <body>
      <p>The parameters in this topic control the configuration of the Greenplum Database PL/Java
        language. </p>
      <simpletable frame="none" id="simpletable_n1h_tzl_zp">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#pljava_classpath"/>
            </p>
            <p><xref href="guc-list.xml#pljava_classpath_insecure"/></p>
            <p>
              <xref href="guc-list.xml#pljava_statement_cache_size"/>
            </p>
            <p>
              <xref href="guc-list.xml#pljava_release_lingering_savepoints"/>
            </p>
            <p>
              <xref href="guc-list.xml#pljava_vmoptions"/>
            </p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
  <topic id="topic_t3n_qml_rz">
    <title>XML Data Parameters</title>
    <body>
      <p>The parameters in this topic control the configuration of the Greenplum Database XML data
        type. </p>
      <simpletable frame="none" id="simpletable_yyd_tml_rz">
        <strow>
          <stentry>
            <p>
              <xref href="guc-list.xml#xmlbinary">xmlbinary</xref>
            </p>
            <p>
              <xref href="guc-list.xml#xmloption">xmloption</xref>
            </p>
          </stentry>
        </strow>
      </simpletable>
    </body>
  </topic>
</topic>
